explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pqxQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 3,731.085 ↓ 0.0 20 1

Limit (cost=0.00..0.00 rows=0 width=0) (actual time=3,731.079..3,731.085 rows=20 loops=1)

2. 3.684 3,731.080 ↓ 0.0 20 1

Sort (cost=0.00..0.00 rows=0 width=0) (actual time=3,731.078..3,731.080 rows=20 loops=1)

  • Sort Key: count(DISTINCT (count(DISTINCT remote_scan.count))) DESC, remote_scan.coarse_key
  • Sort Method: top-N heapsort Memory: 26kB
3. 1,279.233 3,727.396 ↓ 0.0 36,951 1

GroupAggregate (cost=0.00..0.00 rows=0 width=0) (actual time=2,354.747..3,727.396 rows=36,951 loops=1)

  • Group Key: remote_scan.coarse_key
4. 633.981 2,448.163 ↓ 0.0 1,045,793 1

Sort (cost=0.00..0.00 rows=0 width=0) (actual time=2,354.684..2,448.163 rows=1,045,793 loops=1)

  • Sort Key: remote_scan.coarse_key
  • Sort Method: external merge Disk: 49120kB
5. 1,749.697 1,814.182 ↓ 0.0 1,045,793 1

Custom Scan (Citus Real-Time) (cost=0.00..0.00 rows=0 width=0) (actual time=1,724.551..1,814.182 rows=1,045,793 loops=1)

  • Task Count: 16
  • Tasks Shown: One of 16
  • -> Task
  • Node: host=ec2-34-197-128-153.compute-1.amazonaws.com port=5432 dbname=citus
6. 38.675 64.485 ↓ 1.7 65,412 1

HashAggregate (cost=40,259.97..40,640.26 rows=38,029 width=37) (actual time=54.001..64.485 rows=65,412 loops=1)

  • Group Key: coarse_key, id
7. 19.867 25.810 ↓ 1.7 65,412 1

Bitmap Heap Scan on models_assets_cluster_129346 models_assets_cluster (cost=1,501.15..40,069.82 rows=38,029 width=37) (actual time=7.215..25.810 rows=65,412 loops=1)

  • Recheck Cond: ((application_id = '8d4914fbaeca4c8d85c07bd41fe975b0'::text) AND (model_version_id = 'cc73cd06357a469580c2e2a6c03a5553'::text) AND (NOT is_deleted))
  • Heap Blocks: exact=10191
8. 5.943 5.943 ↓ 1.7 65,412 1

Bitmap Index Scan on ma_cluster_cc73cd06357a469580c2e2a6c03a5553_ckey_129346 (cost=0.00..1,491.64 rows=38,029 width=0) (actual time=5.943..5.943 rows=65,412 loops=1)

  • Index Cond: (application_id = '8d4914fbaeca4c8d85c07bd41fe975b0'::text)
Planning time : 1.549 ms
Execution time : 67.909 ms