explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YE5d

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather Motion 2:1 (slice3; segments: 2) (cost=0.00..463.70 rows=1 width=8) (actual rows= loops=)

  • Rows out: 144 rows at destination with 86453 ms to end.
  • (slice0) Executor memory: 402K bytes.
  • (slice1) Executor memory: 1200K bytes avg x 2 workers, 1200K bytes max (seg0). Work_mem: 33K bytes max.
  • (slice2) Executor memory: 6596K bytes avg x 2 workers, 8388K bytes max (seg1). Work_mem: 7161K bytes max.
  • (slice3) Executor memory: 219K bytes avg x 2 workers, 219K bytes max (seg0). Work_mem: 58K bytes max.
  • Memory used: 128000K bytes
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..463.70 rows=1 width=8) (actual rows= loops=)

  • Group By: ekocsp_colu.service_provider
  • Rows out: Avg 72.0 rows x 2 workers. Max 79 rows (seg0) with 86452 ms to end.
3. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..463.70 rows=1 width=8) (actual rows= loops=)

  • Sort Key: ekocsp_colu.service_provider
  • Sort Method: quicksort Max Memory: 49KB Avg Memory: 49KB (2 segments)
  • Rows out: Avg 72.0 rows x 2 workers. Max 79 rows (seg0) with 86452 ms to end.
  • Executor memory: 58K bytes avg, 58K bytes max (seg0).
  • Work_mem used: 58K bytes avg, 58K bytes max (seg0). Workfile: (0 spilling)
4. 0.000 0.000 ↓ 0.0

Redistribute Motion 2:2 (slice2; segments: 2) (cost=0.00..463.70 rows=1 width=8) (actual rows= loops=)

  • Hash Key: ekocsp_colu.service_provider
  • Rows out: Avg 72.0 rows x 2 workers at destination. Max 79 rows (seg0) with 83998 ms to first row, 86452 ms to end.
5. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..463.70 rows=1 width=8) (actual rows= loops=)

  • Group By: ekocsp_colu.service_provider
  • Rows out: Avg 72.0 rows x 2 workers. Max 81 rows (seg1) with 86443 ms to first row, 86452 ms to end.
6. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..463.70 rows=1 width=8) (actual rows= loops=)

  • Sort Key: ekocsp_colu.service_provider
  • Sort Method: quicksort Max Memory: 7161KB Avg Memory: 5369KB (2 segments)
  • Rows out: Avg 63938.0 rows x 2 workers. Max 65820 rows (seg1) with 86443 ms to first row, 86446 ms to end.
  • Executor memory: 5369K bytes avg, 7161K bytes max (seg1).
  • Work_mem used: 5369K bytes avg, 7161K bytes max (seg1). Workfile: (0 spilling)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..463.70 rows=1 width=8) (actual rows= loops=)

  • Join Filter: true
  • Rows out: Avg 63938.0 rows x 2 workers. Max 65820 rows (seg1) with 23 ms to first row, 86393 ms to end.
8. 0.000 0.000 ↓ 0.0

Redistribute Motion 2:2 (slice1; segments: 2) (cost=0.00..32.70 rows=1 width=8) (actual rows= loops=)

  • Hash Key: nefttransaction_col.ekocspid
  • Rows out: Avg 109650.5 rows x 2 workers at destination. Max 110217 rows (seg1) with 19 ms to first row, 104 ms to end.
9. 0.000 0.000 ↓ 0.0

Bitmap Table Scan on nefttransaction_col (cost=0.00..32.70 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: txtime >= '2018-11-15 00:00:00+05:30'::timestamp with time zone AND txtime < '2018-11-16 00:00:00+05:30'::timestamp
  • Rows out: Avg 109650.5 rows x 2 workers. Max 109651 rows (seg0) with 19 ms to first row, 43 ms to end.
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on txtime (cost=0.00..0.00 rows=0 width=0) (actual rows= loops=)

  • Index Cond: txtime >= '2018-11-15 00:00:00+05:30'::timestamp with time zone AND txtime < '2018-11-16 00:00:00+05:30'::timest
  • Bitmaps out: Avg 1.0 x 2 workers. Max 1 (seg0) with 7.982 ms to end, start offset by 36 ms.
  • Work_mem used: 33K bytes avg, 33K bytes max (seg0).
11. 0.000 0.000 ↓ 0.0

Bitmap Table Scan on ekocsp_colu (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: ekocsp_colu.ekocspid = nefttransaction_col.ekocspid
  • Filter: ekocsp_colu.service_provider <> ALL ('{1,11}'::bigint[])
  • Rows out: Avg 63938.0 rows x 2 workers. Max 65820 rows (seg1) with 3.570 ms to first row, 86168 ms to end of 110217 scans.
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_chk_1 (cost=0.00..0.00 rows=0 width=0) (actual rows= loops=)

  • Index Cond: ekocsp_colu.ekocspid = nefttransaction_col.ekocspid
  • Bitmaps out: Avg 109650.5 x 2 workers. Max 110217 (seg1) with 2.114 ms to first, 82334 ms to end of 110217 scans, start offset b
  • Work_mem used: 17K bytes avg, 17K bytes max (seg0).